CREATE TABLE IF NOT EXISTS roles (
  id CHAR(36) NOT NULL,
  name VARCHAR(32) NOT NULL,
  description VARCHAR(64) NOT NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT roles_id_primary PRIMARY KEY (id),
  CONSTRAINT roles_name_unique UNIQUE (name)
);

INSERT INTO roles (id, name, description) VALUES
  ('21bf6853-f390-4f08-8cf0-53e85ce4a37e', 'admin', 'Administrador'),
  ('99bdbbfa-e78d-4412-a8ba-8368d08cce1b', 'user', 'Usuario');
